class CreateUserInfos < ActiveRecord::Migration
  def self.up
    create_table(:user_infos, {:force => true, :options => 'ENGINE=InnoDB DEFAULT CHARSET=utf8'}) do |t|
      t.column :user_id,                  :integer, :default => 0,  :null => false
      t.column :sex,                  :integer, :default => 0,  :null => false
      t.column :signature,            :string
      t.column :address,                     :string
      t.column :qq,                          :string
      t.column :msn,                         :string
      t.column :skpe,                        :string
      t.column :telphone,                    :string
      t.column :mobile,                      :string
      t.column :birthday,                    :datetime
      t.column :interest,                    :string
      t.column :employment,                  :string
      t.timestamps
    end
  end

  def self.down
    drop_table :user_infos
  end
end
